MPOG DataDirect:
User Access & Demonstration
Michael Mathis, MD
Associate Research Director, MPOG
Assistant Professor, Michigan Medicine
Outline
• How to Access
• Key Features
• Version 2.0 Demo
DataDirect Access
DataDirect Access
• Pre-requisites:
–Security Checklist & Authorization Form
–Obtain Login
DataDirect Access
• Pre-requisites:
–Authorization
DataDirect Access
• Pre-requisites:
–Authorization
DataDirect Key Features
• User Guide
DataDirect Key Features
• User Guide
DataDirect Key Features
• Query Modes
– Cohort Only
– Goals:
– Determine if a research/QI question is answerable
– Sample size roughly estimate statistical power
– Ensure a satisfying experience doing MPOG research or QI
– No prior approval
– (except login)
– Multicenter data (counts only)
DataDirect Key Features
• Query Modes
– Single Center Research / Quality Report
– Goal:
– Review cases, processes of care, and outcomes for local research and QI
– Approval from your site leadership
–Implied with DataDirect login, but user re-attests at time of access
– Single center data
DataDirect Key Features
• Query Modes
– Multi-Center Research
– Goal:
– Execute high-impact multicenter research for manuscripts / grants
– Approval from PCRC Committee
– Formal submission/review process
– Multicenter data
DataDirect Key Features
• Query Modes
Access
Requirements
Scope Goal
Cohort Only Login Multicenter
(counts)
Determine if question
is
answerable
Single Center
Research /
Quality Report
Multicenter
Research
DataDirect Key Features
• Query Modes
Access
Requirements
Scope Goal
Cohort Only Login Multicenter
(counts)
Determine if question
is
answerable
Single Center
Research /
Quality Report
Login +
Re-attest with
download
Single Center
Local research / QI
Multicenter
Research
DataDirect Key Features
• Query Modes
Access
Requirements
Scope Goal
Cohort Only Login Multicenter
(counts)
Determine if question
is
answerable
Single Center
Research /
Quality Report
Login +
Re-attest with
download
Single Center
Local research / QI
Multicenter
Research
PCRC Approval Multicenter High-impact
publications / grants
DataDirect v2.0 Updates
DataDirect v2.0
• Major updates
– Intuitive workflow
– Step-wise process
– Differentiation between inclusion criteria vs. covariates/outcomes
– Broader range of data types
– MPOG concepts, phenotypes, QI measures all accessible
– Automated, downloadable data summaries
– QI: Quality Report
– Research: Data Query Spec
DataDirect v2.0 Demo
All cases
Valid case
times, age, sex, CPT, ASA class
ICD
-9/10 codes present, labs present
Mortality,
length of stay, discharge diagnoses
All cases
Intraop
Standard
Valid case
times, age, sex, CPT, ASA class X
ICD
-9/10 codes present, labs present
Mortality,
length of stay, discharge diagnoses
All cases
Intraop
Standard
Periop
Standard
Valid case
times, age, sex, CPT, ASA class X X
ICD
-9/10 codes present, labs present X
Mortality,
length of stay, discharge diagnoses
All cases
Intraop
Standard
Periop
Standard
Outcome
Standard
Valid case
times, age, sex, CPT, ASA class X X X
ICD
-9/10 codes present, labs present X X
Mortality,
length of stay, discharge diagnoses X
DataDirect v2.0
• Outputs
– Single vs. Repeated Measures
Example Values Returned
Single Measures
(One value per case)
Repeated Measures
(Many values per case)
DataDirect v2.0
• Outputs
– Single vs. Repeated Measures
Example Values Returned
Single Measures
(One value per case)
Age MPOG
Case ID, MPOG Patient ID,
Date of Procedure, Value
Repeated Measures
(Many values per case)
DataDirect v2.0
• Outputs
– Single vs. Repeated Measures
Example Values Returned
Single Measures
(One value per case)
Age MPOG
Case ID, MPOG Patient ID,
Date of Procedure, Value
Repeated Measures
(Many values per case)
Blood pressure
MPOG Case ID,
MPOG Patient ID,
BP Source, Dates/Times of
Measurements, Values
… some parting thoughts on data wrangling in MPOG
MPOG Data Wrangling
• Commonly structured, or with cleanable artifact:
– Demographics – height, weight, gender, age, etc.
– Simple case details – ASA class, Anesthesia CPT, duration
– Simple anesthetic details – GA, ETT/LMA attempted
– Elixhauser comorbidities, ICD-9/10 diagnosis codes
– Intraoperative medications
– Standard physiologic monitors
– Laboratory values
MPOG Data Wrangling
• Sometimes unstructured, or with complex artifact:
– Surgical diagnosis and/or procedure text
– Nuanced intraoperative interventions
– e.g. positioning, awake/deep extubation, jet ventilation, partial CPB
– Anesthesia H&P comorbidities
– Non-intraoperative medications (e.g. home, preop, postop)
– Advanced physiologic monitors (e.g. CVP, cerebral oximetry)
MPOG Data Wrangling
Usually Structured,
Cleanable
Sometimes Unstructured,
Cleaning is Challenging or Intractable
Demographics, Labs
MPOG Data Wrangling
Usually Structured,
Cleanable
Sometimes Unstructured,
Cleaning is Challenging or Intractable
Demographics, Labs
Simple Case Details (e.g. Anes CPT) Diagnosis/Procedure Text
MPOG Data Wrangling
Usually Structured,
Cleanable
Sometimes Unstructured,
Cleaning is Challenging or Intractable
Demographics, Labs
Simple Case Details (e.g. Anes CPT) Diagnosis/Procedure Text
Simple Anesthetic Details (e.g. ETT) Nuanced Interventions (e.g. jet vent)
MPOG Data Wrangling
Usually Structured,
Cleanable
Sometimes Unstructured,
Cleaning is Challenging or Intractable
Demographics, Labs
Simple Case Details (e.g. Anes CPT) Diagnosis/Procedure Text
Simple Anesthetic Details (e.g. ETT) Nuanced Interventions (e.g. jet vent)
Comorbidities – Elixhauser Comorbidities – Anesthesia H&P
MPOG Data Wrangling
Usually Structured,
Cleanable
Sometimes Unstructured,
Cleaning is Challenging or Intractable
Demographics, Labs
Simple Case Details (e.g. Anes CPT) Diagnosis/Procedure Text
Simple Anesthetic Details (e.g. ETT) Nuanced Interventions (e.g. jet vent)
Comorbidities – Elixhauser Comorbidities – Anesthesia H&P
Medications – Intraoperative Medications – Home, Preop, Postop
MPOG Data Wrangling
Usually Structured,
Cleanable
Sometimes Unstructured,
Cleaning is Challenging or Intractable
Demographics, Labs
Simple Case Details (e.g. Anes CPT) Diagnosis/Procedure Text
Simple Anesthetic Details (e.g. ETT) Nuanced Interventions (e.g. jet vent)
Comorbidities – Elixhauser Comorbidities – Anesthesia H&P
Medications – Intraoperative Medications – Home, Preop, Postop
Standard Monitors (e.g. BP) Advanced Monitors (e.g. CVP)
Take-Home Points
• DataDirect can catalyze research/QI, without needing:
… to be a computer programmer
… to be a 1
st
-degree relative of your hospital’s CMIO
• DataDirect query modes can be tailored to use-case:
– Cohort ID mode Research/QI “speed dating”
– Single Center Research/QI Improve care at your hospital
– Multicenter Research High-impact science
Thank You
